Forum Discussion

RossB's avatar
RossB
Frequent Visitor
5 years ago
Solved

Data Refresh Fails When Report Merges Data Flow with Another Query Created in Desktop

I have created a report that contains two queries.  One is a dataflow and the other is a query that i created in desktop. I merge the two queries and disable the load of the data flow from the mod...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi RossB 

    Please check whether your SQL Date Source setting is correct.  If you set it correctly, it may show connection successful.

    Here are some blogs about refresh, I hope they could help you.

    Blog: Troubleshooting refresh scenarios

    Blog: Configure scheduled refresh

    Blog: Data refresh in Power BI

    Best Regards,

    Rico Zhou

     

    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

Hi RossB 

I followed your steps to have a test.

Firstly I get data from dataflow (Sheet1) and enter data (Table) directly into Power BI Desktop.

Then I merge two tables in Table and disable load Sheet1.

Then publish this report into Service.

Please check whether your gateway works normally.

If it works well, then check your Data source credentials in Setting - Datasets in Service. Click Edit credentials , select Authentication method and Privacy level. And sign in by your power bi account.

Then I refresh the dataset, it works well.

Best Regards,

Rico Zhou

 

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

RossB's avatar
RossB
Frequent Visitor
5 years ago

Hi Anonymous  that you for the quick response, but i am still having trouble.  Perhaps i can clarify a few things

 

I am merging the data flow with a query that connects to an off premise sql database rather than data i have entered myself .  The error message is as follows

 

I have gone into the credentials and tried to update them however i get the following error message for the SQL connection

 

I am usually able to run reports from this SQL connection even though i have set skip test connections in the gateway. 

 

Next i tried to update my gateway connection by unchecking skip test connections, however....

 

when i uncheck skip test connection i get the following error

 

 

Could this be the cause of the issue?  If so, how do i resolve this, it is a network issue?

 

Thanks in advance

 

Ross

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi RossB 

    Please check whether your SQL Date Source setting is correct.  If you set it correctly, it may show connection successful.

    Here are some blogs about refresh, I hope they could help you.

    Blog: Troubleshooting refresh scenarios

    Blog: Configure scheduled refresh

    Blog: Data refresh in Power BI

    Best Regards,

    Rico Zhou

     

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