Forum Discussion

TimoRiikonen's avatar
TimoRiikonen
Icon for Advocate V rankAdvocate V
9 months ago
Solved

Premium_ASWL_Error with Azure Sharepoint and Lakehouse import data

Hello,   I made a report that combines data from Azure Sharepoint and Lakehouse sources. Both of them using import. There has been issues with on-premise Sharepoint: https://community.fabric.mic...
Need Help
  • TimoRiikonen's avatar
    TimoRiikonen
    9 months ago

     

    I succeeded to fix this though:

    I changed the SQL connection from OAuth2 to service principal / workspace identity.

    Sharepoint worked fine with Personal Cloud Connect setting.

TimoRiikonen's avatar
TimoRiikonen
Icon for Advocate V rankAdvocate V
9 months ago

Zanqueta <

This part "In Power BI Desktop, remove any default connections" is difficult to understand.
You can change default connections in service after you have published, but changing it before publishing...

I don't know how to do that.

Also "Lakehouse: use Single Sign-On if available."

I succeeded after I changed from Single Sign-On OAuth2 to service principle, which is opposite to instructions.

 

So it looks to me like either instructions or functionality is not correct right now.