PowerBI to AS2012 tabular DbpropMsmdCurrentActivityID?

Question

PowerBI to AS2012 tabular DbpropMsmdCurrentActivityID?

wigglo

SSC Veteran

Points: 266
More actions
June 3, 2016 at 11:49 am

#316902

All my reports in Power BI have suddenly stopped working. "Can´t display the visual"
Error in SQL Server Profiler: The DbpropMsmdCurrentActivityID property was not recognized. Error 68
No suggestion from Goggle.
We are using the "old" solution with data management gatway on one server and analysis connector on another server.
Stopped working about a week ago.
Anyone?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Martin Schoombee SSCoach Points: 19128 More actions · Answer 1

You will most likely have to switch to the Enterprise Gateway. See https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/[/url]

wigglo SSC Veteran Points: 266 More actions · Answer 2

Martin Schoombee (6/3/2016)
You will most likely have to switch to the Enterprise Gateway. See https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/[/url]

Yes, I´m afraid so. The Enterprise Gateway works fine.

Is there a way to switch datasource in a PBI report?

Martin Schoombee SSCoach Points: 19128 More actions · Answer 3

wigglo (6/3/2016)
Martin Schoombee (6/3/2016)
You will most likely have to switch to the Enterprise Gateway. See https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/[/url]
Yes, I´m afraid so. The Enterprise Gateway works fine.
Is there a way to switch datasource in a PBI report?

Assuming you mean switching a PBI data source to use the Enterprise Gateway as opposed to the Data Management Gateway...that has to be done for each dataset in the Power BI tenant. I don't know of any other way to do that.

wigglo SSC Veteran Points: 266 More actions · Answer 4

Martin Schoombee (6/3/2016)
wigglo (6/3/2016)
Martin Schoombee (6/3/2016)
You will most likely have to switch to the Enterprise Gateway. See https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise/[/url]
Yes, I´m afraid so. The Enterprise Gateway works fine.
Is there a way to switch datasource in a PBI report?
Assuming you mean switching a PBI data source to use the Enterprise Gateway as opposed to the Data Management Gateway...that has to be done for each dataset in the Power BI tenant. I don't know of any other way to do that.

There is actually only one dataset that has to be changed, but I can´t find out how to do it.

I don´t want build all reports from scratch, that will take days... =(

Martin Schoombee SSCoach Points: 19128 More actions · Answer 5

It should be in the scheduled refresh section of the dataset. Click the ellipses next to the dataset name in the Power BI tenant and select "Schedule Refresh".