Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
ArunKumarPB
New Member

Designing a dashboard using parquet file from local file system

Designing a dashboard using parquet file from local file system/Network Server. Fail to chose valid source type.

Is it possible to create Dashbord/Report from parquet file from local filesyetem?

 

Is there any otherway to do it?

 

2 REPLIES 2
willayd
Advocate I
Advocate I

You can accomplish this using the file URI scheme. Simply use 

 

file:///C:/Users/<the_rest_of_the_path>

 

when prompted for a URL

TomMartens
Super User
Super User

Hey @ArunKumarPB ,

 

at the current moment reading Parquet files is only supported by dataflows, if you are not familliar with Power BI dataflows, I recommend reading the blog posts by Matthew Roche (https://ssbipolar.com/2018/10/19/dataflows-in-power-bi-overview-part-1/#:~:text=Dataflows%20are%20a%...😞

TomMartens_0-1599380767144.png

You can create custom entities (a table) from within the Power BI Service:

TomMartens_1-1599380868175.png

Then you can use Power BI dataflows as a data source in Power BI Desktop:

TomMartens_3-1599381096187.png

 

Be aware that you also have to configure an on-premises gateway that enables the connectivity from the dataflow (Power BI Service) to your Parquet file.

 

Hopefully, this provides some ideas on how to tackle your challenge.

 

Regards,

Tom

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.