Forum Discussion
Power BI migration/Gateway
Good day all I am doing a current migration for Power BI reports. I have set up a test environment and duplicated the Clients environment. I downloaded sample reports and published the it to...
Both of your data sources are "bad".
One is located on someone's computer hard drive. Move that file to a sharepoint or OneDrive.
The other data source expects the SQL server to be on the same machine as the gateway. That is not recommended for a variety of reasons ( massive performance impact, and unsuitable for gateway clusters). Change that onnection to point to a proper separate SQL server.