Forum Discussion

Halloween's avatar
Halloween
Frequent Visitor
3 years ago
Solved

PowerBI Dataflow can't be accessed

Hi

 

I have created PowerBI Dataflows and can schedule the refresh well without having any issue. 

 

However when tried to pull them via Get Data in PowerBI Desktop using the Organizational Account, I always get error messages such as:

* "The given credential could not be refreshed - You're not signed in" 
* "The service returned an invalid token. Please contact your IT Admin if this issue persists"

Please note that creating Workspaces and publish any PBIX to PowerBI App without any issue.

 

The problem is only when the PowerBI Desktop try to get the data from PowerBI Dataflow.

 

Does anyone know how to fix this issue? Many thanks!

 

 


  • Hi Halloween ,


    For this type of error message, you need to make sure that when you create a dataset in Power BI Desktop and then publish it to the Power BI service, the credentials used for the data source of the data stream in Power BI Desktop are the same as the credentials used when publishing the dataset to the service.

     

    Also, to better understand how a dataflow refresh operation performs, review the Refresh History for the dataflow by navigating to Dataflow > Settings > Refresh History. You can also select the dataflow in the Workspace > context menu (…) > Refresh History.

     

    For more details, you can read below document:

    Dataflows Limitations, restrictions and supported connectors and features - Power BI | Microsoft Learn

    Understanding and optimizing dataflows refresh - Power BI | Microsoft Learn

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

5 Replies

  • Halloween , Click on Sign in. It should open a new window. If that does not open. Then do the following.

     

    1. In File -> Options and Settings -> Data source setting-> clear permission of existing data flow connection 

    2. Go to File-> Options and settings -> Options -> Security Option -> and check : Use My Default browser( Visible after scroll)

     

    if need create cache of default browser

     

     

    • SamQC's avatar
      SamQC
      Advocate I

      Hi,
      I have the same issue and tried your solution. It worked for half a day but now the error message is back and I can't seem to be able to fix it...
      Do you have other ideas?

      I don't know if this could be related but I recently upgraded from Power BI Pro to Premium Per User. It was fine for a few days before the error messages poped up...

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support

    Hi Halloween ,


    For this type of error message, you need to make sure that when you create a dataset in Power BI Desktop and then publish it to the Power BI service, the credentials used for the data source of the data stream in Power BI Desktop are the same as the credentials used when publishing the dataset to the service.

     

    Also, to better understand how a dataflow refresh operation performs, review the Refresh History for the dataflow by navigating to Dataflow > Settings > Refresh History. You can also select the dataflow in the Workspace > context menu (…) > Refresh History.

     

    For more details, you can read below document:

    Dataflows Limitations, restrictions and supported connectors and features - Power BI | Microsoft Learn

    Understanding and optimizing dataflows refresh - Power BI | Microsoft Learn

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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