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 published my report to Power BI and then I want to schedule refresh. But it says that my data source credentials are not valid. Pleaser refer to below img. My data source is sql server database and csv and excel file. I didn't change the credentials. Can somebody help me to solve this problem? Thanks.
Solved! Go to Solution.
Hi @Gracie,
In addition, if you are using the personal gateway to refresh data, you will also need to supply the credentials used to connect to the back end data source on Power BI service. You’re only required to sign in to data sources the first time you use refresh on that dataset. Once entered, those credentials are retained with the dataset. For more details, you can refer to this article.
So could you try clicking "Edit credentials", then enter the same credentials you used for each source on Power BI Desktop to see if the refresh works?
Regards
Hi @Gracie,
I have installed personal gateway. I read the article, it says the gateway should be installed on the "always-on" computer. Does it mean if the scheduled refresh happens when the computer is asleep, the refresh will fail ?
The scheduled refresh cannot occur if it’s asleep, and the refresh will not be attempted again until the next scheduled refresh time.
Regards
Hi @Gracie,
In addition, if you are using the personal gateway to refresh data, you will also need to supply the credentials used to connect to the back end data source on Power BI service. You’re only required to sign in to data sources the first time you use refresh on that dataset. Once entered, those credentials are retained with the dataset. For more details, you can refer to this article.
So could you try clicking "Edit credentials", then enter the same credentials you used for each source on Power BI Desktop to see if the refresh works?
Regards
I have installed personal gateway. I read the article, it says the gateway should be installed on the "always-on" computer. Does it mean if the scheduled refresh happens when the computer is asleep, the refresh will fail ?
Hi @Gracie,
I have installed personal gateway. I read the article, it says the gateway should be installed on the "always-on" computer. Does it mean if the scheduled refresh happens when the computer is asleep, the refresh will fail ?
The scheduled refresh cannot occur if it’s asleep, and the refresh will not be attempted again until the next scheduled refresh time.
Regards
Hi there do you have the Power BI Gateway installed?
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 |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |