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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
saujanyae
Helper II
Helper II

Limitation to Direct Query Refresh? https://github.com/microsoft/PowerBI-JavaScript/wiki/Embedding

Are there any limitation to Power BI direct query refresh? 

 

Document link : https://github.com/microsoft/PowerBI-JavaScript/wiki/Embedding---Basic-interactions

 

 

Refresh the underlined data of a report without reset current filters and user interactions. Works only in Direct Query mode. The code below assumes element with id myReport already contains an embedded report:

var element = document.getElementById('#myReport');
var report = powerbi.get(element);

report.refresh()
  .catch(error => { ... });
1 ACCEPTED SOLUTION

Hi @saujanyae ,

 

I can't give you an accurate answer. However, you can make an idea in Ideas forum to let more people see your requirements:
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

8 REPLIES 8
v-eachen-msft
Community Support
Community Support

Hi @saujanyae ,

 

There are currently a few limitations to using DirectQuery:

  • All tables must come from a single database, unless using composite models

  • If the Query Editor query is overly complex, an error will occur. To remedy the error you must either delete the problematic step in Query Editor, or Import the data instead of using DirectQuery. For multi-dimensional sources like SAP Business Warehouse, there is no Query Editor

  • Time intelligence capabilities are not available in DirectQuery. For example, special treatment of date columns (year, quarter, month, day, so on) is not supported in DirectQuery mode.

  • Limitations are placed on DAX expressions allowed in measures to ensure that queries sent to the underlying data source have acceptable performance.

  • There is a one-million-row limit for returning data when using DirectQuery. The limit does not affect aggregations or calculations used to create the dataset returned using DirectQuery, only the rows returned. For example, you can aggregate 10 million rows with your query that runs on the data source, and accurately return the results of that aggregation to Power BI using DirectQuery as long as the data returned to Power BI is less than 1 million rows. If more than 1 million rows would be returned from DirectQuery, Power BI returns an error.

 

Best Regards,

Eads

 

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

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

thank you for your prompt reply. Is there a limitation to the number of refreshes? Our POC has embedded Power BI dashboard in a .net application and when data is updated by user, we want to trigger a refresh.

Hi @saujanyae ,

 

The Data Refresh API shares the same limitation(8 times per day) with "Schedule Refresh" with a Pro license. After exceeding the limitation, the API call would get the response saying "Number of refresh requests in last 24 hours exceeded limit".

If you'd like to lift this limitation, you may have to buy a premium license(48 times per day).

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Thanks for your reply. However, the 48 times a day limits the true integration with a web application where more updates are possible.

I have another question

is there a limitation to the kind of data source used to refresh using javascript API 

Hi @saujanyae ,

 

There is no limit on the kind of data source.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Thank you for your prompt reply. 

 

Do you think in the future the limit on the number of data refreshes will be removed?

 

This will help with complete integration with web applications where we have multiple users making updates impacting backend database.

Hi @saujanyae ,

 

I can't give you an accurate answer. However, you can make an idea in Ideas forum to let more people see your requirements:
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Thank you for your response. I have created an "idea" in  forums for this limitation. 

 

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38560507-limit-to-number-of-refre...

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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