Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Can someone help me understand what this error message is talking about?
I saw people suggest checking if the table names in the power .pbix file and table names in the data source match, which they do, so I'm at a loss on what the issue could be.
Every time I check this error message, the Table name changes to a different table.
We've updated the gateway as well as rebooted the data source db and I still get this error.
Solved! Go to Solution.
I rebooted the server, but that didn't clear the issue either. Instead, I ended up going to the settings for the dataset, going to the Gateways sections changing the On-Prem Dataflows mapping to blank, and changing the cloud Dataflows to a personal connection.
I rebooted the server, but that didn't clear the issue either. Instead, I ended up going to the settings for the dataset, going to the Gateways sections changing the On-Prem Dataflows mapping to blank, and changing the cloud Dataflows to a personal connection.
Hi @Anonymous
Could you update to the latest version of PBI Desktop, open the PBIX and upload again.
Could you also download and install the latest version of the On-Premise Gateway and see if that resolves your error?
Hi @Anonymous
This normally happens when your data source has got Keys that are used in relationships are missing. This then causes it to error. I would suggest refreshing the dataset by opening Power BI desktop and see if the error occurs there which will allow you to fix the error.
Hi @GilbertQ
Thanks for your reply. I was able to refresh successfully in Power BI Desktop. It's only when I try and refresh the dataset in Power BI Serice that I get the issue.
I should note that I have a Power BI Dataflow within the same workspace which the dataset uses in many of its tables as the source. This was working fine a month ago, but then when we updated the gateway we had nothing but issues.
Hi, I am also facing the same issue. Please let me know if you found any solution
I would suggest taking a look at your dataset's settings in the Gateway section.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.