cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DiegoReis Member
Member

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

Accepted Solutions
Community Support Team
Community Support Team

Re: how to publish a report made with directquery

HI @DiegoReis,

 

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 Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
5 REPLIES 5
Super User
Super User

Re: how to publish a report made with directquery

Hi @DiegoReis

 

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 Datanaut!"


Power BI Blog
DiegoReis Member
Member

Re: how to publish a report made with directquery

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

bajee Member
Member

Re: how to publish a report made with directquery

@DiegoReis,

 

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.

DiegoReis Member
Member

Re: how to publish a report made with directquery

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

 

 

Community Support Team
Community Support Team

Re: how to publish a report made with directquery

HI @DiegoReis,

 

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 Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |