Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Error publishing a report with Direct Query over Analysis services

I have a Power BI report where I build on top of a Power BI dataset that is made available to me via a Power BI App (where the publisher of the app granted Build permissions to the users). I am bring...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

v-cazheng-msft thanks for the suggestions. Unfortunately, none of them seem to be the issue:

 

1. I tried publishing to both modern and "old" workspaces - same error;

2. I tried publishing to a workspace on a premium capacity - same error (and the local model I have is tiny, PBIX file is ~200kb)

3. Workspaces I tried using are pretty much empty.

 

I am not exactly sure how large the Power BI dataset I connect to with DQ is, but as it is DQ, I don't think that it would matter in this scenario? (and even then a premium workspace should resolve the issue, which it did not). Any futher suggestions you may have?

 

EDIT: I noticed it actually got published into one of the workspaces I tested (not the premium one, interestingly). However, when I load the report, I get the following issue:

 

Of course, I cannot follow the advice as I cannot republish..

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi Anonymous 

Actually, the report don't need publish to Premium capacity. You can try to republish the report to this workspace. And you can check whether the ‘Use datasets across workspaces’ in your organizational Admin portal> Tenant settings is disabled. If it doesn't work, you can open support ticket for further help.

 

Best Regards

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.