Forum Discussion

JoachimSA's avatar
JoachimSA
Icon for Helper II rankHelper II
4 years ago

Web connector for Excel file on sharepoint

HI everybody,   I use the web connector to import data from an excel file stored on sharepoint (I remove the "?web=1" part at the end of the link) Every once in a while when I work on the import...
Need Help
JoachimSA's avatar
JoachimSA
Icon for Helper II rankHelper II
4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

  • JoachimSA's avatar
    JoachimSA
    Icon for Helper II rankHelper II
    4 years ago

    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 😉