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
v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi Anonymous 

You can try the following steps:

 

1 If the dataset comes from a new workspace, you can't publish it to a classic workspace. Otherwise, you can see the following error information.

 

2 Check the size of the report, the size of datasets normally less than 1 GB. If you are using Premium, you can refer  size considerations in Premium.

 

3 Check the storage of the workspace, if the storage is not enough, the publish of the report will fail

 

 

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.

 

 

  • 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.