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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
senaca
New Member

FetchDatasets was unsuccessful - Using data of Power BI in Excel

I developed a report using data extracted from Power BI in Excel. At the beginning the data was being updated normally, but I tried to change this data set and the error appears: FetchDatasets was unsuccessful.
I tried created a new report on new workbook from excel, but teh same error appearsCaptura de tela 2021-03-08 173632.png

1 REPLY 1
v-rzhou-msft
Community Support
Community Support

Hi @senaca 

Did you use get data from Power BI dataset in Excel?

There may be something wrong when you extract data from Power BI dataset.

Please check whether your account have access to your dataset.

To connect Excel to Power BI dataset, you can try Analyze in Excel function in Power BI.

(Analyze in Excel requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license. )

For Reference: Analyze in Excel

Here is a post with same question like yours, I hope it could help you.

Post: Connect Excel to Power BI Dataset

 

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. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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