Scheduled refresh of a dataset.

[andler67]

Dear all.

i've problems with the scheduled refresh of a dataset.

The source file are excel filed stored in a folder on Onedrive for business.

Every day 8 new files are recorded in the folder at 5am.

i've scheduld a refresh of the dataset at 7am every day but the refresh is unsuccessfull for the following reason.

If i do the refresh with powerBI Desktop i don't have problem.

The problem is only with the scheduled refresh.

Do you have some solution to solve the problem?

Thanks

Best regards

Error: [ValidateMarkupTags][ccon]DataFormat.Error: [ccon]File contains corrupted data.[/ccon]. [/ccon];[ccon]File contains corrupted data.[/ccon]. The exception was raised by the IDbCommand interface. Table: Produzione.

URL cluster: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net

[andler67]

Yes, i used Sharepoint connector. In the folder there are a lot of different files but the first step is to filter file with the same structure

[aj1973]

Ok I see the issue, using Sharepoint Folder connector is useful to directly combine and transform data with same structure. What you did is filtering out some files to combine only files with same structure, isn't it? this could work in Desktop but not in the service. So it is better to put your files with same structure in a folder and connect the folder to Power bi.

[andler67]

Hi.

unfortunately problem not solved.

Now in the Onedrive for business Folder i've only file with the same structure.

i try now to update the semantic model with this result

Errore dell'origine dati: [ValidateMarkupTags][ccon]DataFormat.Error: [ccon]File contains corrupted data.[/ccon]. [/ccon];[ccon]File contains corrupted data.[/ccon]. The exception was raised by the IDbCommand interface. Table: Produzione_oraria.
URI cluster: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
ID attività: d6eecb70-312f-42a4-ae70-000ccb5c327f
ID richiesta: 3630e361-9c57-72ba-8b8c-bd18997be5ce
Ora: 2024-02-15 07:36:30Z

[andler67]

[aj1973]

Hi @andler67 

Are you combining a Folder(Excel files with same structure in it) from OneDrive? if so did you use Sharepoint Folder connector in Power Query?