Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi. Is it possible to import calculated data from one pbix file into another file or report/dashboard?
@Alex_0201 , You can used a published power Bi file as a dataset and use it. In that case, you will only have access to the Visualization tab.
In case you create new formula's and publish the Pbix file user will get new formula after refresh
refer detailed set at :https://www.mssqltips.com/sqlservertip/6155/power-bi-datasets/
@amitchandak thanks for your quick reply!
I might be missing something here.
I have this pbix file, which when I open with PBI desktop, shows me a table with calculated data I am intereseted in.
However, when I upload it to app.powerbi, it shows nothing and returns an error that says "there is no gateway to access the data source".
So when in PBI desktop I use get Data/Power BI datasets, I see the table I need but it is missing the calculated parameters I need.
I've now tried to refresh it manually in app.powerbi twice, and uploaded it to PBI Desktop, but it is still missing the calculated data. Or should I wait for a scheduled refresh in an hour?
Hi @Alex_0201 ,
How the calculated data/parameter looks like in your original pbix file? Could you please provide some screen shots or the related formulas if it has? It is better if you can provide us the pbix file...
It seems its data source is on-premises, then the data gateway is required when publish to Power BI Service. You can review the following documentations for full details about the gateway.
What is an on-premises data gateway?
Best Regards
Rena
refer :https://radacad.com/the-power-bi-gateway-all-you-need-to-know
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
@Alex_0201 Yes.
Refer to this https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
I probably miss something here. After having used "Power BI dataset", I can see the dataset published online. But when I connect to it, there is a table with missing calculated data. This calculated data, however, can be seen if I open the pbix file.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |