Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Blablabla
Advocate I
Advocate I

Invalid dataset. This API can only be called on a Model-based dataset

‎09-03-2024 12:39 AM

I am using an API to refresh my semantic model and I am getting this error :

Invalid dataset. This API can only be called on a Model-based dataset

I get this error when my API call is triggered.

Message 1 of 4
340 Views
1 ACCEPTED SOLUTION
AmiraBedh
Most Valuable Professional
Most Valuable Professional

‎09-03-2024 12:40 AM

It is either you are using DQ or Live connection.

The dataset refresh API doesn't support DirectQuery mode dataset (or Live Connection) because the reports in DQ mode gets the latest data everytime you want to query it, so no need for a refresh.

 

powerbi - logic apps, refresh a dataset of power bi - Stack Overflow


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

View solution in original post

Message 2 of 4
336 Views
3 REPLIES 3
Gabry
Super User
Super User

‎09-03-2024 12:41 AM

Hello @Blablabla ,

the model is in direct query? Or it's a live connection?

Message 3 of 4
336 Views
0
Blablabla
Advocate I
Advocate I
In response to Gabry

‎09-03-2024 12:52 AM

direct qiery

Message 4 of 4
322 Views
0
AmiraBedh
Most Valuable Professional
Most Valuable Professional

‎09-03-2024 12:40 AM

It is either you are using DQ or Live connection.

The dataset refresh API doesn't support DirectQuery mode dataset (or Live Connection) because the reports in DQ mode gets the latest data everytime you want to query it, so no need for a refresh.

 

powerbi - logic apps, refresh a dataset of power bi - Stack Overflow


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
Message 2 of 4
337 Views

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All