Hi in last weeks I'm using Analysis Service to connect to a dataset with:
= AnalysisServices.Database("powerbi://api.powerbi.com/nnn/org/workspace", "Dataset", [TypedMeasureColumns=true, Implementation="2.0"])
The connection now is falling with this error.
Can someone help me?
Solved! Go to Solution.
Hi Ibendlin, really I'm using Excel Power Query to connect to a dataset an deliver an specific report to a team without require to use Internet, they are in a zone with a poor internet quality.
As lbendlin said, I don't think you can directly use AS connector with power bi service URL. You need to use power bi service connector with published datasets.
In addition, if you are work with the poor quality network, maybe you can try to export the data to local DB or file(use import mode instead of the 'data link' to external data sources) then you can use power bi to get data from them.
Hi @v-shex-msft, maybe I explain in a wrong way. I'm following this kind of connection:
I've created the full logic of my report inside of power bi, if I'll use a local db I need to re-create it.
I use power query in excel and connect to powerbi://api.powerbi.com/v1.0/[tenant name]/[workspace name]
Also I've tried to export the dataset to a local db using DAX studio, but it fails with one of my tables.
I've found that solution, and for the last week I could share the "offline" report, but last couple of days I got this error
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.