Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created a report Power BI Desktop that gets data from on-premise SQL Server. I have published the report that I can see on https://app.powerbi.com. I have also installed personal gateway and have gone thru its Wizard. When adding the report to a dashboard and selecting some fields I am gettiing:
Solved! Go to Solution.
Hi @Markzolotoy,
Based on my understanding, it seems that you get data from the SQL Server database use Import mode instead of DirectQuery mode, right?
In your scenario, you can configure dataset use both personal gateway and on-premises data gateway to enable connection to SQL Server data source. From the error message, we can see that the personal gateway is offline currently while this dataset is using this personal gateway, so the connection is failed and data can't be retrieved.
You can open the Power BI Service, then click Settings->Datasets, find the dataset used by this report, then expand Gateway Connection tab, check if personal gateway is running.
If not, you can start the personal gateway follow this article: Power BI Gateway - Personal. Or you can configure a data source connect to the SQL Server database under on-premises data gateway, then set this dataset to use this on-premises data gateway connection, see:
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi @Markzolotoy,
Based on my understanding, it seems that you get data from the SQL Server database use Import mode instead of DirectQuery mode, right?
In your scenario, you can configure dataset use both personal gateway and on-premises data gateway to enable connection to SQL Server data source. From the error message, we can see that the personal gateway is offline currently while this dataset is using this personal gateway, so the connection is failed and data can't be retrieved.
You can open the Power BI Service, then click Settings->Datasets, find the dataset used by this report, then expand Gateway Connection tab, check if personal gateway is running.
If not, you can start the personal gateway follow this article: Power BI Gateway - Personal. Or you can configure a data source connect to the SQL Server database under on-premises data gateway, then set this dataset to use this on-premises data gateway connection, see:
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |