Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a excel file with a Power pivot table and different tables created in the sharepoint. I have imported this file in to Power BI Desktop, developed dashboards for my use, but i have just realised that this file is not being shown in the Data sources, now i am stuck, if i want to replace my source with the new file how do i bring that information in power bi,
Screenshots below,
anyone has a solution?
i have tried to change the source from the Transform data, but the table source is this big , this is crazy
Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("lJ1Jsua4jqX34jVN85LYc1gbqFmM0tLe/neRon4C0kFDMSYRN8Lv5xR7EMQB//u///zznxCOo/35r+unHNPv3+Nf4QgxluuH4+95/fP//P//+//Gf/z5n/+6oRR6uX85Hv3377wBxaMCdAag2t9sUvdvvan0TeV2/KgS469W4Q2l8Pf3x+M7T4JqSr8mSGfbrlVL8dcUbVYu9DdUrYJaagmY+yOZiSaT4wFMbt9MnRU5rGKq2XKttfhmEhRzmkif7UYItMD92RLpx+yfieTjG8nxh9TU/eqIFuhljpp6DwBVn2AOhF6KpHSVJFODYIw6IRPP0n8NV0vjP32+TTdCPGs6gWjYPdVkegQmHN9MSwcw8XvSXdAcmwRhq9kF9YhNgMuPwzTRCMCEbH7d9edYJTESPKpkoAr2arKY8wzYeOW7l0I5xfhpsGSdepxeTD6QqXq2CibVNterOV5Fg2sin3NFaLOrNpbFmMNc7NuctXtQKAjhWj+XbYXFucwRduLKcBrLyQXFALUSu5FbVmwC2/vEuUQ+WN3BSv41SK1BLxBmE5aCxP2fTzkmUisg2HrB/rCWgclQHXNa5ELr0GRC2WmCeiCV96gTKZy2LhUEde5QPdJQf9b4dSf1hMRGJ/XcABGdZDOlALPTSb1mYPY6qTektjqpHEfCZtjppEKmA1M7nVTCQYvYtFzDtyFwUTzbifq07mJJvPRNKKN551BzZ2eqfK7/pc9R3tK2wXpBtMhO6BTbpzUsrqnbEQrfUI13B291RceQclmnfPdJjpmFxdqS5YoqpSye+YzDWlZzrMxFn55DW7YKvwnXbPdJBipL041cA1sfQ//wc=", BinaryEncoding.Base64), Compression.Deflate)))
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!