Unable to connect to dataset on onedrive from service - Error: Failed to configure selected file

[TTZ]

I encournter the following error on Power BI Service when I tried to connect to a dataset stored on OneDrive

From the same One Drive location and to the same service location, I have successfully connected a different dataset (e.g. Dataset A) but this error is encountered when I tried to upload a second dataset (e.g. Dataset B). 

Can anyone please advise how I can get around with this error? Is there anything in the dataset that is causing this issue?

Thanks,

Ting

[v-yingjl]

Hi @TTZ ,

Based on my test, cannot reproduce it in my environment when connect to .pbix file which stores in OneDrive.

Maybe you can check:

1. Can your .pbix file be opened normally in PBI Desktop? Is it possible that your .pbix file is damaged?

2. Please check whether you have access to this .pbix file

3. Try to re-upload the file to OneDrive and connect it in power bi service again.

Best Regards,
Yingjie Li

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

[amitchandak]

@TTZ , Check what can wrong and troubleshooting on

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive

[Greg_Deckler]

@TTZ I don't think you can do that, am I wrong @lbendlin ?

[lbendlin]

This is actually possible, and can be used for cheap Version Control purposes (assuming you enable that in OneDrive, and the .pbix are not too big).

However, that is just for storage and as a data source.  As far as I remember that does not include scheduled refresh of the .pbix file itself (a la Excel Workbooks), only scheduled refresh from the pbix file.

https://community.powerbi.com/t5/Power-Query/Power-BI-Desktop-with-One-Drive-Sync/td-p/76316

[lbendlin]

Are you talking about .pbix files stored on OneDrive? The term "dataset"  has a slightly different meaning, it is not something that is stored anywhere by itself.

[TTZ]

Yes, I was talking about .pbix files stored on OneDrive. Cheers