Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Cannot refresh Data Lake Store datasource

Hi there,

 

For some reason I am not able to refresh my published report, which has a Data Lake Store as datasource.

 

In desktop I have setup a simple report using a Data Lake Store which reads multiple csv's from a folder and combines them into a single table. I am able to refresh the data in the desktop version.

 

But when I publish this to the service I see this message at the dataset settings:

 

You can't schedule refresh for this dataset because one or more sources currently don't support refresh.

Query contains unknown or unsupported data sources.

 

I used my personal AAD account (with 2FA) to login to the Data Lake Store.

 

Any ideas how I can get this to work?

 

Thanks in advance.

4 REPLIES 4
sundarram
Frequent Visitor

I am facing the same problem. Please keep us updated if you find a solution or work around for the problem

v-shex-msft
Community Support
Community Support

Hi @Anonymous,

 

I think this issue may due to combine operate. If you only import single csv file without any operation(combine, expand, reference), refresh operation may works smoothly.


In addition, MFA verification also can be a reason of failed refresh, you can also turn off MFA and test combined source.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

@v-shex-msft

 

Disabled 2FA and tried to only read a single file, but still not working...

 

Refresh in the service should work with Data Lake Store as datasource right?

 

This is my query by the way:

 

let
    Source = DataLake.Contents("adl://datalakerbot.azuredatalakestore.net", null),
    #"Raw Data" = Source{[Name="Raw Data"]}[Content],
    #"2017" = #"Raw Data"{[Name="2017"]}[Content],
    #"Afvaldata log 01-2017 txt" = #"2017"{[Name="Afvaldata log 01-2017.txt"]}[Content],
    #"Imported CSV" = Csv.Document(#"Afvaldata log 01-2017 txt",[Delimiter=";", Columns=7, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(#"Imported CSV", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"timestamp", type text}, {"BA [ton]", type number}, {"HHAWEG [ton]", type number}, {"GA [ton]", type number}, {"IMP [ton]", type number}, {"HHABoot [ton]", type number}, {"HHAtotaal [ton]", type number}})
in
    #"Changed Type"
Anonymous
Not applicable

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors