Scheduled daily refresh of a .pbix file connected to an Azure Online Database for free users

[haechleriwan]

Hi

I've created a report in Power BI Desktop and connected it to an Azure SQL Database. I published the .pbix file and created a dashboard out of it, which is being shared with other users. 

When I schedule a daily refresh, the free users with whom I shared the dashboard can not see it anymore. Even if I schedule a refresh every other day, it still does not work. Only Pro Users can access it. However, according to https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/, a daily data refresh should be available for free users, too. 

If I don't schedule a refresh, the data does not automatically update!

What am I doing wrong?

Thank you for your help.

[DipteshPatel]

I'm having an issue with a Dataset failing to refresh and it would appear to be to do with the fact my model is blending data from two separate databases in two separate Azure servers. I've created a report in PBI Desktop that connects to our separate DEV and PROD Azure Servers with no issues - Desktop lets me blend the data without a complaint.

I set up a schedule for refresh, but it always fails and 

The Refresh history messages shows a seemingly random table each time as being the one to trip it up.

If Power BI Desktop is letting me blend these sources in to the same report, what is it about the Service that is preventing it?

Is it a bug in the Service, or intentional for some reason? Is there a suggested workaround?

[DipteshPatel]

I'm having an issue with a Dataset failing to refresh and it would appear to be to do with the fact my model is blending data from two separate databases in two separate Azure servers. I've created a report in PBI Desktop that connects to our separate DEV and PROD Azure Servers with no issues - Desktop lets me blend the data without a complaint.

I set up a schedule for refresh, but it always fails and 

The Refresh history messages shows a seemingly random table each time as being the one to trip it up.

If Power BI Desktop is letting me blend these sources in to the same report, what is it about the Service that is preventing it?

Is it a bug in the Service, or intentional for some reason? Is there a suggested workaround?

[Anonymous]

Hi @haechleriwan,

How do you connect to Azure SQL database from Power BI Desktop? Using import mode or DirectQuery mode? If you connect to Azure SQL database using DirectQuery mode, your dashboard contains Power BI Pro content, the users you shared dashboard with should have pro license to view reports.

Thanks,
Lydia Zhang

[haechleriwan]

Dear @Anonymous Lydia,

Thank you for your support.

However, I do not use DirectQuery mode. The connection is established by import mode. Any idea why it does not work?

Thank you,

[Anonymous · Accepted solution]

Hi @haechleriwan，

I am not able to reproduce your issue.

What error message do the users get? Do you publish your report to "My Workspace" or Power BI Group?

Thanks,
Lydia Zhang

[haechleriwan]

Hi @Anonymous

I've uploaded a new database and for some reason, this time everything works! 

Thank you very much for your kind support.

[kapil512]

Hi @haechleriwan,

Regarding the below thread, can you please help me out.

When you do shedule refresh for Import model for Azure SQl.

Did you configure Gateway?

If not can you please let me know how go forword with out gateway, actually my data is on Azure Sql and  i am using the Impoert model.

Thanks,

Kapil