Forum Discussion

Evogelpohl's avatar
Evogelpohl
Helper V
4 years ago

Potential Bug - Using Hive Style Partition Folder Name on ADLS Gen2 with Service Refresh

Noticed an issue today w/ PowerBI.Com using files on ADLS Gen2 as my source and publishing to the service using an access-key for credentials.   I recently changed the structure of my data lake fil...
General Comment
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Evogelpohl ,

 

How did you get workbook from ADLS Gen2? I think your issue should be casued by not updating data source credential in Power BI Service. If you republish your workbook to Power BI Service, you will republish the new credential and data to Power BI. So it will work well.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Evogelpohl's avatar
    Evogelpohl
    Helper V
    4 years ago

    How did I connecto ADLG Gen2? 

    Using the in-built connector: =
    Source = AzureStorage.DataLake("https://mystorage.dfs.core.windows.net/data/zone=bronze/source=xxx")

     

    I tried the following to attempt to fix whilst having the /zone=bronze/source=xxx in the first Source line:

    1. In PowerBi Desktop - removed all creds, global, forcing a total re-login for ADSL, republish, - works in the desktop, fails in service.

    2. Tried both a KEY and an OAuth/my-organizational azure account - works in desktop, republish, fails in service.

    3. Create entire new test PBIX, with /zone=bronze/..., works in Desktop, fails in Service.

     

    1,2,3 all work in both the Desktop and Service when i remove the /zone=bronze/source=xxx and filter it in line two. 

     

    HTHs.