Forum Discussion
Web connector for Excel file on sharepoint
Hi JoachimSA ,
Can you provide a screenshot of the error message?
What I'd suggest is:
1. Clear the Power BI cache, File -> Options and Settings -> Options -> (GLOBAL) Data Load -> click on "Clear Cache".
2. Re create the report from scratch.
There is also to ensure that Power BI Desktop is the latest version.
For creating relationships, there is an automatic relationship creation function that you can try to use, which may reduce the difficulty of your work. Reference: Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Stephen,
I tried the cache clearing without success.
The error window is in German:
Also: it seems to help to save the file without applying the Power Query changes and then opening the PBIX again...strange
Hi JoachimSA ,
Sorry I don't know the language in your screenshots, maybe you should try to open a support ticket for help.
Go to https://powerbi.microsoft.com/en-us/support/ ,scroll down and click "CREATE SUPPORT TICKET" for further help if you are a pro user.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The German error says "the sequence does not contain data".
I now moved away from the DQ approach. Instead I export a "condensed" version of my result as Excel FIle using DAX Studio. For this I use multiple EVALUATE statements with SUMMARIZECOLUMNS for the needed fact and dimension tables (always including the primary key). This seems to work a lot more stable. moreover, I can version my exports and even build a little tool to compare the within power BI 😉