Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
I try to upload my semantic model, but I do get this error. Basically this error is about the last step in specific table (or just 1 different table). It's always one of those two tables. I looked for multiple solutions and tried a lot already, uploading it in different ways, changing the privacy settings, but nothing helped. The weird thing is that I can refresh the data in my power BI desktop without any problem. Only when I try to upload this model, I get this error everytime again. I searched and tried different solutions I found, but nothing helped so far.
Maybe good to know is that I make use of incremental refresh as well (when it works). I make use of an ODBC server. I tried to upload just a different tables, which works, also with refreshing in power bi service.
Hi @Wonter
@lbendlin Thanks for your sharing !
From the error message in the image you uploaded, there seems to be an issue with the credentials or permissions of the data source you are using in the model.
Here are some possible solutions you can try:
Clear the cached credentials in Power BI Desktop. Go to File > Options and Settings > Data Source Settings and select Clear Permissions to clear any cached credentials.
Check semantic model permissions in Power BI Services. Ensure that you have the required permissions to access the published semantic model. Confirm with the semantic model owner or administrator that you have been granted access.
Log in to the Power BI service and attempt to upload a Power BI report from the target workspace using the upload option.
If you are using a gateway to connect to the data source, ensure that the gateway is online and configured correctly. You can check the gateway status and settings under Manage Gateways in the Power BI service.
If you are using different data sources in your model, ensure that they have the same privacy level. You can check and change the privacy level under File > Options and Settings > Options > Privacy in Power BI Desktop.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Last thing I want to mention: In these specific tables, I merge different tables
Don't. Avoid merging whenever possible, especially across data source types.
If you must, refactor your query to keep everything in the same partition.
Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn
User | Count |
---|---|
35 | |
32 | |
21 | |
11 | |
8 |
User | Count |
---|---|
54 | |
43 | |
28 | |
13 | |
11 |