Forum Discussion

PowerBI_Nic's avatar
PowerBI_Nic
New Member
1 year ago

guest user unable to access data from workspace

I have downloaded linked data from Power BI into Excel and was able to refresh the data successfully. However, I am now unable to refresh the data. The dataset resides in a different tenant where I am a guest user. Despite being able to log in to Power BI without issues, the refresh function in Excel has stopped working.

Technical details:

  • The dataset is in a different tenant.

  • I am a guest user in the tenant.

  • I can log in to Power BI and access the dataset without any issues.

  • The data refresh in Excel, which was previously working, has now stopped.

interesting thing is, same dataset in "myworkspace" still work and I am able to refresh the data.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi  PowerBI_Nic ,

     

    Could you please provide me with details of the error you are experiencing with the refresh function in Excel?

    In addition to that, you mentioned that the same dataset in “myworkspace” is still valid, so if you can, you can check the following points:

    1 Are the credentials provided with the dataset the same?

    2 Are the gateways used to link to the datasource the same, and if they are different, have you been granted the same permissions?

    3 If you create a new dataset to connect to excel, do you encounter the same problem, or is it that the desktop refreshes successfully, but the service still encounters errors?

    Data refresh in Power BI - Power BI | Microsoft Learn

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.