Forum Discussion

SAALLGOR's avatar
SAALLGOR
Regular Visitor
2 years ago
Solved

Power Bi Desktop - SQL Server - Power BI Cloud

Good morning, let me start by saying that I am new to this forum so forgive me if I make something wrong. Our company has recently adopted Power BI (the free version) to analyze data present in a SQL...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi SAALLGOR ,

    Make sure that all datasets used in the report have been connected through the On-premises data gateway.
    Please note that On-premises data gateway (Personal mode) only supports data sources connected in Import mode, if your report is in DirectQuery mode or Live Connection mode in Desktop, please download On-premises data gateway (Standard mode):
    Download On-premises data gateway from Official Microsoft Download Center
    For more information about the difference between Personal mode and Standard mode, you can refer to this document:
    Use a personal gateway in Power BI - Power BI | Microsoft Learn
    To use On-premises data gateway (Standard mode), you need to manually create a connection for your data source in Power BI Service:

    For more information about how to create a data source connection, you can refer to this document：
    Add or remove a gateway data source - Power BI | Microsoft Learn

    Best Regards,

    Dino Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mattiasdesmet's avatar
mattiasdesmet
Resolver II
2 years ago

Did you configure the datasources on the dataset? Click on the ... behind the dataset and click on Settings. In the section "Gateway and cloud connections" you have to map each source to a "data source" on the gateway. Were these sources created and is the connection succesful?