Forum Discussion
Support from Microsoft Power BI
Sure thing..
We have our DW connected to an on-premise SSAS Tabular model. We use 1 dataconnection to get data, and we (still) use Analysis Services Connector.
All of a sudden on Tuesday our reports (and connection) started saying "unable to load the model" and then failing.
1) We have rebooted the SAAS server also hosting the connector
2) The connector claims to be connected (Connected: You're good to go!)
3) The SQL profiler (connected to SAAS) shows no hits from PowerBI when I try to load the data
4) I have installed the Enterprise gateway, new connections from that connector gives me data
There is one possible clue that I have. When I open the Analysis Services Connector, click edit, changes the "Friendly error message" and click "Save" I get the following:
(!) The data at the root level is invalid. Line 1, position 1.
There has been no changes to the connector (config changes) the last week before this problem appeared.
I am reluctant to uninstall the Power BI Analysis Services Connector right now, as that would only add another factor to the situation.
Thanks ankitpatira :)
Hi hereri. Are you using the Enterprise Gateway or the old SSAS connector? I believe the old connector is not longer supported (although I'm not sure if that means it will no longer work or not). This post mentions it is no longer supported:
https://powerbi.microsoft.com/en-us/blog/power-bi-gateways-april-update.
We upgraded to the Enterprise Gateway a while ago, and from memory it was pretty seamless upgrade.
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-upgrade-as-connector/
I can understand your reluctance to change anything though. Power BI is very fragile. I also undestand your frustrations with support.
Hi cmn,
We are using the old connector, which works for several of our customers. You will not see the old connector while trying to create new connections.
I have installed the new connector, and added my user to it. I was under the impression that all connections would then "migrate" to the enterprise connector for my user. If so, it still fails :)
Hi cmn and ankitpatira ... any of you seen the same problem as I have? I have been struggelig with this since Tuesday and the Power BI team seems to have gone into hibernation.
I would appriciate any community assistance :)
hereri I'm assuming when you set up the EG that you created a Datasource matching the same datasource, you didn't specify in your description. And were the reports built in Desktop and pushed to the Service, or did you connect directly from the Service?