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

1) SharePoint has been set. Lakehouse is not visible here.

2) The report has only two connections: Azure Sharepoint and Lakehouse that uses SQL connection.

Here is my SQL connection as M code:
let
Source = Sql.Databases("1234.datawarehouse.fabric.microsoft.com"),
gold = Source{[Name="gold"]}[Data],
#"Filtered Rows" = Table.SelectRows(gold, each ([Item] = "ourdata")),
3) I have tested a few options for the Azure Sharepoint but I always get still the same error.

Credentials mapped.

4) Done. Breaks still when doing the manual refresh.

 

> https://learn.microsoft.com/power-bi/connect-data/service-gateway-onprem

We are not using onprem systems, so I did not find anything that I thought would be relevant in this document.