Forum Discussion

jPinhao's avatar
jPinhao
Advocate II
9 years ago

Direct Query Source in Import Data mode - Pro licence?

We've just changed how our Power BI service acquires data, and it's now directly connected to an Azure SQL Database. Now when I try to access it in teh portal I get a notice saying something along th...
Need Help
jPinhao's avatar
jPinhao
Advocate II
9 years ago

Thanks v-qiuyu-msft, this is what I thought. How come I'm seeing this Pro notice then? If I turn off the daily refresh everything is good, but with it enabled the report won't load.

 

This is a slight inconvenience as it means I have to go to the portal and hit refresh myself every morning.

 

 

That is how I have set-up the refresh. As you can see it is a pretty standard daily refresh, not more than daily, and yet the service seems to think the dataset has Pro content :(

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi jPinhao,

 

Please double check based on this article to verify this report doesn't contain any Pro content.

 

Did you connect to another data source in this report? Based on my test, if use one query connect to the Azure SQL database in Import mode without any RLS enabled, after publish to the service and enable schedule refresh, report can be loaded fine. Would you please share the detail steps for our analysis?

 

Best Regards,
Qiuyun Yu