Power BI Data Refresh Issue using Direct Query Analysis Services

[sadafriaz]

I have two Datasets as below
1. Company1

2. Company2

Both are separately published and connected to respective Gateway and refreshing successfully.

Now i want to combine both companies data into a single table so i used following approach.

Created another pbix file and connected both datasets and used Calculated table and Union to combine both companies. But issue is when i publised this to Power BI service it gives me error and not refreshing data what actually have in Company 1 and Company2.

Note: using Pro License 

Dataset connections are here 

Refresh Error on gateway

Please guide whats wrong in this and do we have another way to combine tables data from two different datasets ?

[sadafriaz]

I have achieved this using Data flow

[v-rongtiep-msft]

Hi @sadafriaz ,

I found a similar case , maybe you can refer to it .

Advice when using a DirectQuery and dataflow toget... - Microsoft Power BI Community

• Calculated tables and calculated columns that reference a DirectQuery table from a data source with Single Sign-on (SSO) authentication are not supported in the Power BI Service.

If it still does not help, please provide more details.

Best Regards
Community Support Team _ Polly

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