cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
koorosh
Helper IV
Helper IV

storage mode

1 ACCEPTED SOLUTION
negi007
Super User
Super User

@koorosh when you connect to powerbi dataset from powerbi desktop application, you will automatically get live connection to dataset. since dataset is something which is already published and updated by the owner so you wont get option to import and make changes to it. Only the changes from the owner will be visible on refresh.

 

Considerations and limitations 

When using the Power BI service live connection, there are a few considerations and limitations to keep in mind.

  • Only users with Build permission for a dataset can connect to a published dataset using the Power BI service live connection.
  • Free users only see datasets in their My Workspace and in Premium-based workspaces.
  • Since this connection is a live connection, left-navigation and modeling are disabled. You can only connect to one dataset in each report. This behavior is similar to the behavior when connected to SQL Server Analysis Services. However, the following article describes how a new feature in Power BI now makes this possible: see using DirectQuery for Power BI datasets and Azure Analysis Services (preview)
  • Since this connection is a live connection, row-level security (RLS) and other such connection behaviors are enforced. This is the same as when connected to SQL Server Analysis Services.
  • If the owner modifies the original shared .pbix file, the dataset and report that is shared in the Power BI service is overwritten. Reports based on that dataset aren't overwritten, but any changes to the dataset are reflected in the report.
  • Members of a workspace can't replace the originally shared report. Attempts to do so result in a warning that prompts you to rename the file, and publish.
  • If you delete the shared dataset in the Power BI service, then other reports based on that dataset will no longer work properly or display their visuals.
  • Deleting a shared dataset in the Power BI service means no one can access that dataset any longer from Power BI Desktop.
  • Reports that share a dataset on the Power BI service don't support automated deployments using the Power BI REST API.

 

Please refer to this link on connection to dataset from desktop

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

 

Please refer to below link for a workaround on this mode

https://radacad.com/how-to-import-data-from-a-power-bi-dataset-premium-only

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


View solution in original post

1 REPLY 1
negi007
Super User
Super User

@koorosh when you connect to powerbi dataset from powerbi desktop application, you will automatically get live connection to dataset. since dataset is something which is already published and updated by the owner so you wont get option to import and make changes to it. Only the changes from the owner will be visible on refresh.

 

Considerations and limitations 

When using the Power BI service live connection, there are a few considerations and limitations to keep in mind.

  • Only users with Build permission for a dataset can connect to a published dataset using the Power BI service live connection.
  • Free users only see datasets in their My Workspace and in Premium-based workspaces.
  • Since this connection is a live connection, left-navigation and modeling are disabled. You can only connect to one dataset in each report. This behavior is similar to the behavior when connected to SQL Server Analysis Services. However, the following article describes how a new feature in Power BI now makes this possible: see using DirectQuery for Power BI datasets and Azure Analysis Services (preview)
  • Since this connection is a live connection, row-level security (RLS) and other such connection behaviors are enforced. This is the same as when connected to SQL Server Analysis Services.
  • If the owner modifies the original shared .pbix file, the dataset and report that is shared in the Power BI service is overwritten. Reports based on that dataset aren't overwritten, but any changes to the dataset are reflected in the report.
  • Members of a workspace can't replace the originally shared report. Attempts to do so result in a warning that prompts you to rename the file, and publish.
  • If you delete the shared dataset in the Power BI service, then other reports based on that dataset will no longer work properly or display their visuals.
  • Deleting a shared dataset in the Power BI service means no one can access that dataset any longer from Power BI Desktop.
  • Reports that share a dataset on the Power BI service don't support automated deployments using the Power BI REST API.

 

Please refer to this link on connection to dataset from desktop

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

 

Please refer to below link for a workaround on this mode

https://radacad.com/how-to-import-data-from-a-power-bi-dataset-premium-only

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors