How do I use a data gatway data source in PowerBI Desktop?

ComputerHabit 781 Reputation points
2024-04-03T14:42:16.78+00:00

It seems like I can't find a reasonable document that explains how to use a PowerBI Data source that is created using the DataGateway.

Could someone please explain why I can't select it? Am I supposed to be able to choose this data source from PowerBI Desktop?

I keep looking for a way to use the datasources and cannot find anything.

Microsoft Power Platform Training
Microsoft Power Platform Training
Microsoft Power Platform: An integrated set of Microsoft business intelligence services.Training: Instruction to develop new skills.
61 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ComputerHabit 781 Reputation points
    2024-04-03T14:44:43.0666667+00:00

    What a mess... User's image

    0 comments
  2. Syed Saleem Peera 545 Reputation points Microsoft Vendor
    2024-04-19T11:08:36.9566667+00:00

    Hi ComputerHabit,

    The Power BI Gateway is a crucial component of Microsoft Power BI. It serves as a bridge between the Power BI service in the cloud and your on-premises data sources. Here’s what you need to know:

    Purpose: The Power BI Gateway allows you to securely connect and refresh data from your on-premises data sources within Power BI reports and dashboards.

    Functionality:

    Data Transfer: It facilitates data transfer between the cloud-based Power BI service and your on-premises data sources.

    Refreshing Data: You can keep your dashboards and reports up to date by connecting to on-premises data without physically moving the data.

    Controlled Access: The gateway ensures secure and controlled access to your on-premises data.

    Modes:

    Standard Mode: This mode serves multiple users with access control per data source. It supports features like DirectQuery and live connections to Analysis Services.

    Personal Mode: In this mode, the gateway runs as a single user with your credentials. It’s suitable for scenarios where you’re the sole user accessing on-premises data.

    Installation and Setup:

    Easy Installation: Download and install the gateway with minimal interactions.

    Single Gateway for Multiple Services: You can use the same gateway for Power BI, Power Apps, Power Automate, and Azure Logic Apps.

    Security:

    Data transfer between Power BI and the on-premises data gateway is secured through Azure Service Bus.

    Credentials provided by gateway administrators are encrypted, ensuring protection of your information in the cloud.

    If you are still facing any issue, please let us know in the comments. We are glad to help you.

    If the information is helpful, please Accept Answer so that it would be helpful to community members.

    Thank you.

    0 comments