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.
To the PBI Community,
I have developed a PBI file which uses data from API sources and which includes three tables imported from my local machine. The API sources all use basic auth and all use the same credentials. Privacy level is set to Organizational for all. The three excel tables have been set to not refresh and I've played around with having Privacy = None, Organizational and Public. The file refreshes in the PBI Desktop without issues, but as soon as I publish and try to refresh in the service, I get an error message prompting me:
Then the "Data source credentials" options in the settings page is disabled (greyed out).
Again, this file needs to automatically refresh on a schedule without needing to access the files on my local machine. I thought by excluding the local tables from refresh, the service would not consider them.
1. Is there a way to get a more granular diagnostic from the service, e. g. to isolate which data sources are causing this? I would like to confirm that the problem is with the local files - even though excluded from the refresh.
2. Should I simply recreate these Lookup / Fact tables in the PBI Desktop using "Enter Data"? Would that solve the problem?
I do not wish to install a gateway and make the file dependent on access to my local file system.
Thank you,
Henrik
Hi @waeltken
If I understand you have an API which is refreshing all local files on your PC?
If that is the case in order for the dataset to refresh it has to have some data source to refresh otherwise it will not be able to refresh when there is nothing to refresh?
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.