ACTION REQUIRED BY 7/31/2017 to avoid interruption in your Power BI Data refresh of on-premises data
Microsoft Analysis Server 10.50.600.34
Microsoft Analysis Services Client Tools 14.0.608.142
Are you suggesting this could be a version compatible issue?
@starmoonknightIt was something our IT dept suggested to me, I am not convinced myself given that is still works in power bi desktop, particularly if your software is newish (ours is quite old I believe)
There is some version info here: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/
Thanks @nickgraves for the link.
Have you tried to uninstall Analysis Services and run the gateway? When did your problem start occuring?
No we have not tried to uninstall AS, (our systems are supported by an outside company & I am on holiday at the moment)
It happened as soon as we foolishly updated the gateway software.
Connections to all our other systems are ok, problem just with AS cubes and just through the gateway (both personal and standard modes)
Hi - we installed this update as we have a few data models that use data sources not yet supported by the Data Gateway Enterprise mode.
Unfortunately, we had to uninstall the update as it does not support all the data sources that the existing Personal Gateway supports.
Specifically, we are refreshing Active Directory Data. I recognize (now! :)) that that lack of AD support (along with others) is detailed in the linked documentation under Limitations and considerations, but considering that data refresh via the existing personal gateway will stop working in 7 weeks, I am surprised at the lack of feature parity. I see OLEDB, ODBC, Spark and R being developed, but no AD mention.
@dimazaid, while I applaud unifying and simplifying, we are going to have a problem if 2017-07-31 rolls around and On-premises data gateway (personal mode) is not at feature parity for supported connections with the existing Personal Gateway.
Any chance we'll get feature parity and have Active Directory support via either Data Gateway? We are very dismayed right now that features that have worked since July 2015 are being removed and breaking all the Intelligence and work we have done. See my related posts about the new 10 GB Uncompressed Data limit imposed on the Data Gateway Refreshes that magically appeared without warning on June 1, 2017.
We have 125 Power BI Pro Licenses. We have now stopped buying them because my confidence has been eroded around what other limitations and restrictions will magically appear. It is clear that we are being funnelled to the Power BI Premium which represents a MASSIVE increase in cost for a company with 230 IT Users. I would feel better about it if I could actually determine if a P1 Node would solve my problem, but there is not test, no trial, no tools to evaluate, etc... Just a web site with a slider and a whitepaper.
Thank you for the feedback and for using the gateway! We will be looking into adding AD based on this, I will respond back with an ETA once it's clear.
p.s: Sorry if you're getting this twice, I sent a response yesterday but can't see it anymore.
Which auth type are you using with ODBC? Basic or Windows? Do they see any errors other than the loading data message?
Can you send me the gateway logs so we can take a look?
It was my mistake. I created dashboard with pinned page and I wanted to create something like menu for reports. I deleted pinned page and left dashboard without it but only text boxes with links to reports. After added again pinned page everything was fine. False alarm 🙂
One question regarding new on-premises data gateway(personal mode). When I upgrade gateway will I still have an access to my ODBC data? I use Basic authentication.
Glad to hear it was resolved!
The new gateway supports ODBC data source with Basic mode today, so you should be able to still access your data. Please let me know if you see otherwise.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.