Forum Discussion
Direct Query Source in Import Data mode - Pro licence?
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
v-qiuyu-msft, we're not connecting to any other source no. The only data loading step we have is:
Source = Sql.Database(Server, Database, [CreateNavigationProperties=false])
Where Server and Database are 2 parameters. We've had issues iwth paramters in the data source query step, but that was related to static analysis not knowing where to get the data from, and it wouldn't refresh at all (not what's happenign now).
The rest of the queries just follow on from this 'Load Data' query, navigating to a particular table and doing some transformations. In one of the query tables we do a Join with another table (from the same project), but I don't imagine this should be an issue either:
MergeExistingSessionsLicence = Table.NestedJoin(dbo_Fact_SessionRun, {"session_id"}, ExistingSessionsLicence, {"session_id"}, "Licence", JoinKind.LeftOuter),
As I mentioned, if I turn off the automatic refresh everything is fine. The issue only really shows itself with automatic refresh turned on. None of the other points in the link you posted (which I read before) don't sound applicable to our case. The issue really seems to be with the automatic refresh.
Could it be a potential bug with the automatic refresh? I've just tried setting it up to work every other day using the 'Weekly' option, and that still throws up a Pro warning.
Is there a way to share this dataset/report with a msft representative?
EDIT: I can't seem to do manual refreshes in the portal either now. The refresh notification very briefly appear on teh top right of the browser, but it immediately disappears and the dataset never gets the loading spinner next to it's name. I'm having to refresh this manually in teh desktop version and publish to the portal.
EDIT 2: Seems like the inability to do manual refreshes in the portal was just a glitch - this is now working again :)