Forum Discussion

wycd's avatar
wycd
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago
Solved

My dataset is grayed out

I have one pulished dashboard with SSAS dataset behind. Yesterday I made some change in SSAS tubular DB and added one tab in pbix file. All looked good after publishing it to online. 

 

However, today I checked on the report and dataset. Found out that the changes made yesterday are gone. So I tried to republish the pbix file. The publishing process took very long time, so I cancled a few times. 

 

Later I found out that my data set is grayed out. I don't know when the gray out happened. Now I start getting "no access to the dataset" error message when publishing.

 

Anyone could help me with this issue? Thanks in advance!

 

  • ankitpatira's avatar
    ankitpatira
    10 years ago

    wycd not 100% sure but i think since you cancelled the process of publish from desktop to service your dataset in cloud is locked and so greyed out. i think you should contact microsoft support to be able to get access back to that dataset.

     

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi wycd,

     

    In your scenario, please make sure the user account used to access the Power BI Service is the same one as used before. And please try to connect to .PBIX file from Power BI Service site via Get Data feature to see if the dataset can be replaced with the new one.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

6 Replies

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion
    10 years ago

    wycd not 100% sure but i think since you cancelled the process of publish from desktop to service your dataset in cloud is locked and so greyed out. i think you should contact microsoft support to be able to get access back to that dataset.

     

    • wycd's avatar
      wycd
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      Thank you for the reply ankitpatira. Seems that you are right about why my dataset was greyed out. My dataset is reactivated one day later.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    10 years ago

    Hi wycd,

     

    In your scenario, please make sure the user account used to access the Power BI Service is the same one as used before. And please try to connect to .PBIX file from Power BI Service site via Get Data feature to see if the dataset can be replaced with the new one.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

    • wycd's avatar
      wycd
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      Thank you for the reply, v-qiuyu-msft. I could update my report and dataset via Power BI Service site after the dataset is reactived.