PowerBI to AS2012 tabular DbpropMsmdCurrentActivityID?

  • wigglo

    SSC Veteran

    Points: 216

    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?

  • Martin Schoombee

    SSCoach

    Points: 19027

    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: 216

    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: 19027

    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: 216

    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: 19027

    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".

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

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