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...
  • 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.