Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI Team,
I have connected to power bi dataset with analysis service mode in power bi desktop(import mode) and the report was working fine earlier and refresh happing without error. where from few days i am getting refresh error which are published with my credentials. and i am not able to connect to any power BI dataset using analysis service(import mode). where i have Pro license and reports are published in premium work space.
Solved! Go to Solution.
400 usually means a malformed DAX query. But in your case it sounds more like expired credentials.
Hi @malleshG ,
I have connected to power bi dataset with analysis service mode in power bi desktop(import mode) and the report was working fine earlier and refresh happing without error
Have you changed any settings recently? For example, settings in Admin Portal, or settings of your environment, or switch from Premium Gen1 to Premium Gen2, etc..
and i am not able to connect to any power BI dataset using analysis service(import mode). where i have Pro license and reports are published in premium work space.
What's your Premium SKU?
Are you able to connect to Power BI Dataset in Shared Capacity (pro workspace)?
Only you encountered such an issue in your organization?
In addition, what's your Power BI Desktop version and Power BI Service version?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Are you running a custom DAX query against the dataset?
No Not yet, checking with other users and internal admin team for access issues
Yes, I am using dax query. earlier it was working fine, now am getting the error while validating my credentials, mean now i am not able to connect any power BI data set in anlysis service mode
400 usually means a malformed DAX query. But in your case it sounds more like expired credentials.
Power BI admin was disabled the analyze in excel option, now its enabled and i am able to connect and refresh the data set
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.