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'm having problems (only online service, offline works well) refreshing files with combining tables. All sources are Sheets.
This is the error:
{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"Information is needed in order to combine data"}}],"exceptionCulprit":1}}} Table: table_name.
Solved! Go to Solution.
Hi @bi_babel-azza ,
Please download the report and open it in Power BI desktop, go to Query Editor, refresh data to see if any message pops out. Also please go to the Data Source Settings, click on Edit Permission for these two data sources points to two databases, ensure both privacy level is Organizational.
Then republish the report to Power BI service, go to Manage Gateways, ensure Privacy Level for these two SQL data sources is Organizational as well. Then refresh the dataset again.
You can also refer the following simliar issues that hope to help you:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @bi_babel-azza ,
Please download the report and open it in Power BI desktop, go to Query Editor, refresh data to see if any message pops out. Also please go to the Data Source Settings, click on Edit Permission for these two data sources points to two databases, ensure both privacy level is Organizational.
Then republish the report to Power BI service, go to Manage Gateways, ensure Privacy Level for these two SQL data sources is Organizational as well. Then refresh the dataset again.
You can also refer the following simliar issues that hope to help you:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
The link shows a problem with date filter, not my case.
I'm trying to open a support ticket, but even been a Pro user it is not allowing me, it is saying that I need a Premier ID (never asked that before).
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.