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
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.