Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Solved! Go to Solution.
@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.
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
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
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.
@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.
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.
How did it get reactivated?
I waited for one day then the dataset turn to reactive automatically. I assumed that the backend process ended and then unblocked the dataset. I think you could contact microsoft support for help, if you don't want to wait.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.