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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

how to publish a report made with directquery

hello guys can you help me please? "-" 

 

how to publish a report made with directquery and when to refresh your browser it shows the last update??

 

ty

1 ACCEPTED SOLUTION

HI @Anonymous,

 

Please take a look at below link to know more about power bi data refresh.

Data refresh in Power BI

If your dataset is configured for a live or DirectQuery connection, datasets are refreshed approximately each hour or when interaction with the data occurs. You can manually adjust the refresh frequency in the Scheduled cache refresh option in the Power BI service.

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

5 REPLIES 5
GilbertQ
Super User
Super User

Hi @Anonymous

 

If you want to publish a report with DirectQuery, you will have to have the On-Premise Data Gateway installed.

You would then need to configure the On-Premise Data Gateway with the DirectQuery Data Source.

 

Once the above is done, you can then upload your Power BI Report. Once it has been uploaded it should notify you that it is connected to the Gateway.


In terms of refreshing it will automatically refresh everytime you click on a Visual.

You can configure the refresh cycle for the Dashboard Items.

 

Here are some links:

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

gateway configuration is OK
power BI + sql is OK

in my power bi service it's okay

I put it to refresh in 15 min.

In my power service worked, however when I published the link and accessed from another computer I refresh the page every 10 minutes and it has already passed 1 hour and still has not got the latest updates

HI @Anonymous,

 

Please take a look at below link to know more about power bi data refresh.

Data refresh in Power BI

If your dataset is configured for a live or DirectQuery connection, datasets are refreshed approximately each hour or when interaction with the data occurs. You can manually adjust the refresh frequency in the Scheduled cache refresh option in the Power BI service.

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

@Anonymous,

 

What is your Size of the datasource your using.

 

If you direct query we have a limitation 1M Records we can only fetch using direct query.

 

Regards,

Bajee.

Anonymous
Not applicable

100 rows maybe 100kb I think ^^

 

I need to force the refresh I try to public my Dash look:

Refresh 15 min

 

 

https://app.powerbi.com/view?r=eyJrIjoiYTNjYmZlZDUtNDEzNi00ZTU5LWJiZDUtZTE1ZjE3MDY2NGJhIiwidCI6ImVhZ...

 

Ty

 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.

Top Solution Authors
Top Kudoed Authors