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
394 Views
1 ACCEPTED SOLUTION
AmiraBedh
Super User
Super User

‎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
390 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
390 Views
0
Blablabla
Advocate I
Advocate I
In response to Gabry

‎09-03-2024 12:52 AM

direct qiery

Message 4 of 4
376 Views
0
AmiraBedh
Super User
Super User

‎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
391 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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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

View All